Screen capture showing the logical `CHANNEL` dimension mapped to columns in the `CHANNEL_DIM` table in the `GLOBAL` schema. The `PRIMARY` hierarchy has two levels: `TOTAL_CHANNEL` and `CHANNEL`.

Mappings for `TOTAL_CHANNEL` are as follows: `Member` maps to `GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_ID`, `LONG_DESCRIPTION (American)` maps to `GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC`, `LONG_DESCRIPTION (French)` maps to `GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC_FRENCH`, and `LONG_DESCRIPTION (Dutch)` maps to `GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC_DUTCH`.

Mappings for `CHANNEL` are as follows: Member maps to `GLOBAL.CHANNEL_DIM.CHANNEL_ID`, `LONG_DESCRIPTION (American)` maps to `GLOBAL.CHANNEL_DIM.CHANNEL_DSC`, `LONG_DESCRIPTION (French)` maps to `GLOBAL.CHANNEL_DIM.CHANNEL_DSC_FRENCH`, and `LONG_DESCRIPTION (Dutch)` maps to `GLOBAL.CHANNEL_DIM.CHANNEL_DSC_DUTCH`.